UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8FDVY+9V+aQ7fhONYqmSOtJjB+XvC+PvlZxg0GtUkPs='
WHERE
key_id = '164c3f602a0b653d27b19a50466da055cc30ec88653492a9316a2b8165332718'
AND (
token = '8FDVY+9V+aQ7fhONYqmSOtJjB+XvC+PvlZxg0GtUkPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)