UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wt3nh8rxrg717yQ15EOZ24VTIkvNTYKKc87BcbgMZQU='
WHERE
key_id = 'fd51c4116f13e3aa7ae8a7c06d3c05bb23eb8d817364fea71bda91efa8939b7c'
AND (
token = 'wt3nh8rxrg717yQ15EOZ24VTIkvNTYKKc87BcbgMZQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)