UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zB96OEwU5tH7pBAiTcRC7JoRV3nRwwNdpf46VyY9GTE='
WHERE
key_id = '5f7da34ad4fe2831def81df7d7a75fc3785ff8c485ee48dc4d156763a945253a'
AND (
token = 'zB96OEwU5tH7pBAiTcRC7JoRV3nRwwNdpf46VyY9GTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)