UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c1r1liZu6tN1Fq9Zj5PcmcRCq8/R23ci5Dgy2CF3x/0='
WHERE
key_id = 'e851c055c7af29e51c0864f106ef330c7ef9d172ab72bd00fbf297753305fed4'
AND (
token = 'c1r1liZu6tN1Fq9Zj5PcmcRCq8/R23ci5Dgy2CF3x/0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)