UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2i96BbTEE5JacD5Y5fZbz1kKr7WReHawmG5dN6aFqPo='
WHERE
key_id = 'b65a9d598662f6b709bc2d6d41195d16735e201e00bb58d3f0f7146fe27a61f2'
AND (
token = '2i96BbTEE5JacD5Y5fZbz1kKr7WReHawmG5dN6aFqPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)