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