UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EF7vUmd8a7kFwbbPxpVsLRitBQ8iedix1b3jAbNGKu4='
WHERE
key_id = '58a271abcc756b2c07a06599749c561770e585e6f8b0e0c6eb7f5e35692cb945'
AND (
token = 'EF7vUmd8a7kFwbbPxpVsLRitBQ8iedix1b3jAbNGKu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)