UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PDCmEe1cWAyzJIwkls2dDGYBJXPhfbu8Il8ioQfOlMk='
WHERE
key_id = 'd1350e0ed7e026c32ae791ba836a538b7b333be43bb01addc571670a62069ef8'
AND (
token = 'PDCmEe1cWAyzJIwkls2dDGYBJXPhfbu8Il8ioQfOlMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)