UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z6jknUL5Wm8tTQvLNnc0/G/2u69q1VDl62gF7z1rFJ4='
WHERE
key_id = 'a12e2720fccee6333aef2913fe41df043f67cada61e2472532c730a59adf5360'
AND (
token = 'Z6jknUL5Wm8tTQvLNnc0/G/2u69q1VDl62gF7z1rFJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)