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