UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bC1psXvoQgcqlJpsc2zxdyseAsO5d0GIO+cW56yzVO0='
WHERE
key_id = '5072314e41d0d69fa2e94005b7559135e6b0156036afffb05c45777cd21ad4f2'
AND (
token = 'bC1psXvoQgcqlJpsc2zxdyseAsO5d0GIO+cW56yzVO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)