UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B1Mvgh7DrQ33bi9REdeGhPhNbDANBjcxGEw/3jk/UEA='
WHERE
key_id = '4c0ab225333ef39d8a9fa92529ccd8542e51a22f213ca9fafffdd93ab21fdb23'
AND (
token = 'B1Mvgh7DrQ33bi9REdeGhPhNbDANBjcxGEw/3jk/UEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)