UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8/Pkpd1YXlW+67lnapsr/DmDQCZSMDWwC/+PaAbxBs='
WHERE
key_id = '4c50342c492d5efe880ef79ff879a9c3029b6e58310f7cf0e3182346dc074b04'
AND (
token = 'J8/Pkpd1YXlW+67lnapsr/DmDQCZSMDWwC/+PaAbxBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)