UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27T6Q1Gr6xBBmewm+5VpgeZR4AuSEkkf3+zs1N98/Wg='
WHERE
key_id = '5ec0b01a3c949445f7c219680fb69ef18e49ba44d9a019745dac19f39a1d3436'
AND (
token = '27T6Q1Gr6xBBmewm+5VpgeZR4AuSEkkf3+zs1N98/Wg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)