UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CAC0pSaQ3HOYh40JkprOeDyvh5pLPZgAe+TvuZwqYEs='
WHERE
key_id = '3e40cf8a8a0b0a7555eda872470fdc54615d6aaf11ac8ee69806bcb20008dab9'
AND (
token = 'CAC0pSaQ3HOYh40JkprOeDyvh5pLPZgAe+TvuZwqYEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)