UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5o9E3DbHHgDyeJWT10AFp8/3nrgeCnEa3q4GBWTNkxM='
WHERE
key_id = '0cfda550cac41344c69bf9dfc687be252c238560884e4ab8687118e1ace17a5c'
AND (
token = '5o9E3DbHHgDyeJWT10AFp8/3nrgeCnEa3q4GBWTNkxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)