UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tgRfFvuE7BZlheOHliV+ScWifWgzPHXKiLNa6UC7lYQ='
WHERE
key_id = '016727be1539c642bd060f3dcd491dff70af8116219b06b0168a063ec8c92ef7'
AND (
token = 'tgRfFvuE7BZlheOHliV+ScWifWgzPHXKiLNa6UC7lYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)