UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iBd/HXdczhJSroRcqscoobDJUfwCaqS7G0SZBQ1l0Go='
WHERE
key_id = 'a4ac4a4b3192a396b3e871c93b0d5c0dbfe7ff486a647e101990a50d5f8ddacd'
AND (
token = 'iBd/HXdczhJSroRcqscoobDJUfwCaqS7G0SZBQ1l0Go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)