UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oKTJdEMmViApktT15J0yGzZansZD+4EsVBGpCX/VEjw='
WHERE
key_id = '0b9968fb18090c57cc05381ab9cd23ddbafa612b2002a00ba1c57eeeb684273f'
AND (
token = 'oKTJdEMmViApktT15J0yGzZansZD+4EsVBGpCX/VEjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)