UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pDwFSY5HwGGrdSIPcpBgm6zS0qWU166bqf+FLmNKkGM='
WHERE
key_id = 'c42d709f839b7fa9004d8385b496efdb7f939081b8b0b1e25f8a0799f2a1285e'
AND (
token = 'pDwFSY5HwGGrdSIPcpBgm6zS0qWU166bqf+FLmNKkGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)