UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8TlDMMxyr7IcDEjmVi5kn4ZMImvzQPI4f7FLcrDgDIo='
WHERE
key_id = 'a832b7868474c4123aba2fbac6dcefdd9a2f8e6d7ef4c386c837b007889d0bf8'
AND (
token = '8TlDMMxyr7IcDEjmVi5kn4ZMImvzQPI4f7FLcrDgDIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)