UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GnwCVUqiexsoti1Dx/5gr8d0cvWHFNlrWS+PxaRQU40='
WHERE
key_id = '505cf9f3eac556f45a2d0b4cbaa31dfdf95ea1d854b717f0d12ff69c03710190'
AND (
token = 'GnwCVUqiexsoti1Dx/5gr8d0cvWHFNlrWS+PxaRQU40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)